Professional Visual Basic 2012 and .NET 4.5 by Bill Sheldon & Billy Hollis & Rob Windsor & David McCarter & Gaston Hillar & Todd Herman

Professional Visual Basic 2012 and .NET 4.5 by Bill Sheldon & Billy Hollis & Rob Windsor & David McCarter & Gaston Hillar & Todd Herman

Author:Bill Sheldon & Billy Hollis & Rob Windsor & David McCarter & Gaston Hillar & Todd Herman
Language: eng
Format: epub, mobi
Publisher: John Wiley & Sons
Published: 2012-12-06T16:00:00+00:00


SQL Server .NET Data Provider

The SQL Server .NET data provider uses Tabular Data Stream (TDS) to communicate with the SQL Server. This offers a great performance increase, as TDS is SQL Server's native communication protocol that can be up to 70 percent faster than the OLE DB .NET data provider.

Note

This is very important, as going through the OLE DB or ODBC layers means that the CLR has to marshal (convert) all of the COM data types to .NET CLR data types each time data is accessed from a data source. When using the SQL Server .NET data provider, everything runs within the .NET CLR, and the TDS protocol is faster than the other network protocols previously used for SQL Server.



Download



Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.